Search Results for: "SIG Sauer P210 Standard 9mm Luger Semi Auto Pistol"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='SIG Sauer P210 Standard 9mm Luger Semi Auto Pistol ' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 218218 then 1 
 when 250170 then 2 
 when 198931 then 3 
 when 291781 then 4 
 when 277576 then 5 
 when 205238 then 6 
 when 264644 then 7 
 when 263211 then 8 
 when 137602 then 9 
 when 291096 then 10 
 when 250171 then 11 
 when 158537 then 12 
 when 291094 then 13 
 when 132087 then 14 
 when 268755 then 15 
 when 284838 then 16 
 when 250397 then 17 
 when 289714 then 18 
 when 88551 then 19 
 when 155841 then 20 
 when 283475 then 21 
 when 262978 then 22 
 when 246408 then 23 
 when 157927 then 24 
 when 162555 then 25 
 when 244959 then 26 
 when 213381 then 27 
 when 123538 then 28 
 when 168522 then 29 
 when 156448 then 30 
 when 268663 then 31 
 when 277979 then 32 
 when 168070 then 33 
 when 217217 then 34 
 when 192568 then 35 
 when 284006 then 36 
 when 168069 then 37 
 when 193375 then 38 
 when 195483 then 39 
 when 267328 then 40 
 when 195484 then 41 
 when 219944 then 42 
 when 251969 then 43 
 when 266700 then 44 
 when 211037 then 45 
 when 155772 then 46 
 when 48126 then 47 
 when 214888 then 48 
 when 64020 then 49 
 when 202779 then 50 
 when 147585 then 51 
 when 202750 then 52 
 when 144448 then 53 
 when 199042 then 54 
 when 205240 then 55 
 when 175432 then 56 
 when 205255 then 57 
 when 111737 then 58 
 when 227133 then 59 
 when 189589 then 60 
 when 262986 then 61 
 when 87888 then 62 
 when 116293 then 63 
 when 120430 then 64 
 when 129534 then 65 
 when 141427 then 66 
 when 155227 then 67 
 when 157716 then 68 
 when 162540 then 69 
 when 251526 then 70 
 when 249134 then 71 
 when 268155 then 72 
 when 152857 then 73 
 when 267905 then 74 
 when 48158 then 75 
 when 112780 then 76 
 when 79479 then 77 
 when 189580 then 78 
 when 183755 then 79 
 when 197445 then 80 
 when 206669 then 81 
 when 291782 then 82 
 when 205256 then 83 
 when 249778 then 84 
 when 129502 then 85 
 when 129975 then 86 
 when 79095 then 87 
 when 120706 then 88 
 when 163767 then 89 
 when 163769 then 90 
 when 119381 then 91 
 when 214489 then 92 
 when 255466 then 93 
 when 227689 then 94 
 when 277783 then 95 
 when 287455 then 96 
 when 181371 then 97 
 when 215812 then 98 
 when 267141 then 99 
 when 278367 then 100 
 when 210647 then 101 
 when 200119 then 102 
 when 217129 then 103 
 when 210649 then 104 
 when 253368 then 105 
 when 257085 then 106 
 when 264484 then 107 
 when 300686 then 108 
 when 115813 then 109 
 when 268154 then 110 
 when 268093 then 111 
 when 246375 then 112 
 when 254350 then 113 
 when 189787 then 114 
 when 189701 then 115 
 when 277967 then 116 
 when 286716 then 117 
 when 303866 then 118 
 when 193230 then 119 
 when 204077 then 120 
 when 228095 then 121 
 when 277941 then 122 
 when 199113 then 123 
 when 200120 then 124 
 when 198835 then 125 
 when 217212 then 126 
 when 168073 then 127 
 when 246380 then 128 
 when 249691 then 129 
 when 256328 then 130 
 when 267380 then 131 
 when 246371 then 132 
 when 291472 then 133 
 when 193408 then 134 
 when 303799 then 135 
 when 144144 then 136 
 when 131507 then 137 
 when 130326 then 138 
 when 251088 then 139 
 when 251814 then 140 
 when 217128 then 141 
 when 214889 then 142 
 when 246384 then 143 
 when 246403 then 144 
 when 246407 then 145 
 when 246331 then 146 
 when 283415 then 147 
 when 211391 then 148 
 when 134115 then 149 
 when 152874 then 150 
 when 103495 then 151 
 when 131840 then 152 
 when 131500 then 153 
 when 188134 then 154 
 when 205239 then 155 
 when 250202 then 156 
 when 276194 then 157 
 when 233710 then 158 
 when 286721 then 159 
 when 165464 then 160 
 when 246817 then 161 
 when 113466 then 162 
 when 213506 then 163 
 when 291168 then 164 
 when 262977 then 165 
 when 192893 then 166 
 when 225885 then 167 
 when 219792 then 168 
 when 209942 then 169 
 when 246377 then 170 
 when 250504 then 171 
 when 255468 then 172 
 when 278779 then 173 
 when 283645 then 174 
 when 277968 then 175 
 when 291634 then 176 
 when 172159 then 177 
 when 218178 then 178 
 when 303798 then 179 
 when 298000 then 180 
 when 117397 then 181 
 when 110981 then 182 
 when 250200 then 183 
 when 267937 then 184 
 when 132164 then 185 
 when 162542 then 186 
 when 131581 then 187 
 when 289697 then 188 
 when 121691 then 189 
 when 286720 then 190 
 when 168071 then 191 
 when 303423 then 192 
 when 303745 then 193 
 when 138432 then 194 
 when 168604 then 195 
 when 201609 then 196 
 when 205173 then 197 
 when 202476 then 198 
 when 201657 then 199 
 when 220441 then 200 
 when 250201 then 201 
 when 260515 then 202 
 when 163766 then 203 
 when 214887 then 204 
 when 115469 then 205 
 when 189594 then 206 
 when 122445 then 207 
 when 152861 then 208 
 when 152900 then 209 
 when 309315 then 210 
 when 277784 then 211 
 when 162539 then 212 
 when 205375 then 213 
 when 149988 then 214 
 when 285334 then 215 
 when 162543 then 216 
 when 113489 then 217 
 when 74602 then 218 
 when 215964 then 219 
 when 122442 then 220 
 when 181405 then 221 
 when 263215 then 222 
 when 260512 then 223 
 when 280259 then 224 
 when 253555 then 225 
 when 277234 then 226 
 when 250203 then 227 
 when 269834 then 228 
 when 222100 then 229 
 when 280596 then 230 
 when 270054 then 231 
 when 301227 then 232 
 when 137158 then 233 
 when 113450 then 234 
 when 256329 then 235 
 when 267507 then 236 
 when 219943 then 237 
 when 148090 then 238 
 when 175956 then 239 
 when 217768 then 240 
 when 246409 then 241 
 when 289701 then 242 
 when 309302 then 243 
 when 198833 then 244 
 when 297699 then 245 
 when 207504 then 246 
 when 282862 then 247 
 when 77945 then 248 
 when 81891 then 249 
 when 168072 then 250 
 when 289695 then 251 
 when 117396 then 252 
 when 120769 then 253 
 when 138431 then 254 
 when 301548 then 255 
 when 260511 then 256 
 when 264776 then 257 
 when 250204 then 258 
 when 263864 then 259 
 when 71050 then 260 
 when 250221 then 261 
 when 125108 then 262 
 when 202782 then 263 
 when 262948 then 264 
 when 222482 then 265 
 when 222333 then 266 
 when 280956 then 267 
 when 290652 then 268 
 when 155884 then 269 
 when 218104 then 270 
 when 282983 then 271 
 when 287453 then 272 
 when 289699 then 273 
 when 298287 then 274 
 when 201710 then 275 
 when 215559 then 276 
 when 269029 then 277 
 when 247846 then 278 
 when 289734 then 279 
 when 207474 then 280 
 when 207505 then 281 
 when 296456 then 282 
 when 305631 then 283 
 when 296584 then 284 
 when 292817 then 285 
 when 277237 then 286 
 when 202783 then 287 
 when 289719 then 288 
 when 89606 then 289 
 when 129979 then 290 
 when 274250 then 291 
 when 276195 then 292 
 when 301378 then 293 
 when 305651 then 294 
 when 300611 then 295 
 when 308275 then 296 
 when 86578 then 297 
 when 247883 then 298 
 when 270053 then 299 
 when 298961 then 300 
 when 86480 then 301 
 when 118320 then 302 
 when 155226 then 303 
 when 285809 then 304 
 when 263257 then 305 
 when 257300 then 306 
 when 284839 then 307 
 when 218468 then 308 
 when 286717 then 309 
 when 227545 then 310 
 when 222485 then 311 
 when 217906 then 312 
 when 152363 then 313 
 when 252130 then 314 
 when 262449 then 315 
 when 297384 then 316 
 when 299070 then 317 
 when 149765 then 318 
 when 197396 then 319 
 when 175958 then 320 
 when 217905 then 321 
 when 262983 then 322 
 when 214517 then 323 
 when 202845 then 324 
 when 249450 then 325 
 when 251036 then 326 
 when 291635 then 327 
 when 218176 then 328 
 when 290651 then 329 
 when 280258 then 330 
 when 252127 then 331 
 when 301228 then 332 
 when 200118 then 333 
 when 285431 then 334 
 when 89610 then 335 
 when 289739 then 336 
 when 298697 then 337 
 when 279326 then 338 
 when 138438 then 339 
 when 262949 then 340 
 when 208907 then 341 
 when 213634 then 342 
 when 277235 then 343 
 when 137160 then 344 
 when 140013 then 345 
 when 89299 then 346 
 when 298217 then 347 
 when 298216 then 348 
 when 263038 then 349 
 when 297582 then 350 
 when 250614 then 351 
 when 214516 then 352 
 when 169811 then 353 
 when 139938 then 354 
 when 218175 then 355 
 when 283648 then 356 
 when 250205 then 357 
 when 277966 then 358 
 when 253981 then 359 
 when 198834 then 360 
 when 126337 then 361 
 when 210846 then 362 
 when 293051 then 363 
 when 150129 then 364 
 when 273503 then 365 
 when 175957 then 366 
 when 254415 then 367 
 when 262206 then 368 
 when 303690 then 369 
 when 262203 then 370 
 when 283650 then 371 
 when 280745 then 372 
 when 251882 then 373 
 when 121988 then 374 
 when 151347 then 375 
 when 271313 then 376 
 when 271041 then 377 
 when 120342 then 378 
 when 216276 then 379 
 when 247848 then 380 
 when 252883 then 381 
 when 188991 then 382 
 when 262981 then 383 
 when 285097 then 384 
 when 201674 then 385 
 when 196811 then 386 
 when 228147 then 387 
 when 228144 then 388 
 when 228141 then 389 
 when 287575 then 390 
 when 214891 then 391 
 when 179496 then 392 
 when 204062 then 393 
 when 204061 then 394 
 when 148567 then 395 
 when 246328 then 396 
 when 175326 then 397 
 when 159485 then 398 
 when 170821 then 399 
 when 144251 then 400 
 when 283392 then 401 
 when 205254 then 402 
 when 169809 then 403 
 when 138097 then 404 
 when 206469 then 405 
 when 148134 then 406 
 when 158312 then 407 
 when 201655 then 408 
 when 221021 then 409 
 when 247732 then 410 
 when 94966 then 411 
 when 228150 then 412 
 when 198548 then 413 
 when 114629 then 414 
 when 261465 then 415 
 when 169804 then 416 
 when 195453 then 417 
 when 225294 then 418 
 when 280000 then 419 
 when 114838 then 420 
 when 291085 then 421 
 when 298434 then 422 
 when 298481 then 423 
 when 196632 then 424 
 when 179487 then 425 
 when 260894 then 426 
 when 196812 then 427 
 when 206005 then 428 
 when 208933 then 429 
 when 193214 then 430 
 when 286276 then 431 
 when 286277 then 432 
 when 158311 then 433 
 when 301850 then 434 
 when 176040 then 435 
 when 205236 then 436 
 when 180058 then 437 
 when 196633 then 438 
 when 247451 then 439 
 when 216781 then 440 
 when 271308 then 441 
 when 170697 then 442 
 when 191500 then 443 
 when 280595 then 444 
 when 202860 then 445 
 when 201654 then 446 
 when 201652 then 447 
 when 210121 then 448 
 when 298167 then 449 
 when 196526 then 450 
 when 205813 then 451 
 when 246815 then 452 
 when 286285 then 453 
 when 148343 then 454 
 when 293544 then 455 
 when 280730 then 456 
 when 205433 then 457 
 when 285394 then 458 
 when 205251 then 459 
 when 138569 then 460 
 when 205241 then 461 
 when 141661 then 462 
 when 150211 then 463 
 when 284453 then 464 
 when 280160 then 465 
 when 193218 then 466 
 when 193224 then 467 
 when 195452 then 468 
 when 206018 then 469 
 when 285113 then 470 
 when 298165 then 471 
 when 193205 then 472 
 when 168301 then 473 
 when 225363 then 474 
 when 221036 then 475 
 when 155230 then 476 
 when 220874 then 477 
 when 206455 then 478 
 when 89297 then 479 
 when 282760 then 480 
 when 252554 then 481 
 when 199795 then 482 
 when 138437 then 483 
 when 249345 then 484 
 when 165466 then 485 
 when 252128 then 486 
 when 214890 then 487 
 when 206452 then 488 
 when 249449 then 489 
 when 303688 then 490 
 when 281165 then 491 
 when 222524 then 492 
 when 170687 then 493 
 when 193223 then 494 
 when 211975 then 495 
 when 208482 then 496 
 when 280967 then 497 
 when 301377 then 498 
 when 220209 then 499 
 when 255183 then 500 
 when 281486 then 501 
 when 213844 then 502 
 when 293056 then 503 
 when 293057 then 504 
 when 206466 then 505 
 when 205248 then 506 
 when 253257 then 507 
 when 138605 then 508 
 when 286482 then 509 
 when 215561 then 510 
 when 158686 then 511 
 when 170704 then 512 
 when 248653 then 513 
 when 288972 then 514 
 when 152843 then 515 
 when 225361 then 516 
 when 255173 then 517 
 when 155622 then 518 
 when 290906 then 519 
 when 277781 then 520 
 when 208481 then 521 
 when 201653 then 522 
 when 72816 then 523 
 when 137472 then 524 
 when 261510 then 525 
 when 293047 then 526 
 when 260776 then 527 
 when 261491 then 528 
 when 213380 then 529 
 when 216928 then 530 
 when 70304 then 531 
 when 280513 then 532 
 when 289737 then 533 
 when 211392 then 534 
 when 283643 then 535 
 when 304186 then 536 
 when 122444 then 537 
 when 283651 then 538 
 when 89614 then 539 
 when 227954 then 540 
 when 263829 then 541 
 when 134509 then 542 
 when 205253 then 543 
 when 70300 then 544 
 when 161825 then 545 
 when 191697 then 546 
 when 277919 then 547 
 when 217130 then 548 
 when 133210 then 549 
 when 186944 then 550 
 when 218177 then 551 
 when 222478 then 552 
 when 245230 then 553 
 when 285481 then 554 
 when 87024 then 555 
 when 132602 then 556 
 when 79756 then 557 
 when 252354 then 558 
 when 278695 then 559 
 when 283411 then 560 
 when 152877 then 561 
 when 113453 then 562 
 when 113449 then 563 
 when 124715 then 564 
 when 170682 then 565 
 when 170724 then 566 
 when 211036 then 567 
 when 195486 then 568 
 when 173900 then 569 
 when 218179 then 570 
 when 202846 then 571 
 when 216504 then 572 
 when 288973 then 573 
 when 150574 then 574 
 when 123424 then 575 
 when 217903 then 576 
 when 121056 then 577 
 when 261953 then 578 
 when 301158 then 579 
 when 286887 then 580 
 when 247847 then 581 
 when 277239 then 582 
 when 271311 then 583 
 when 125460 then 584 
 when 249453 then 585 
 when 176419 then 586 
 when 79755 then 587 
 when 47985 then 588 
 when 285139 then 589 
 when 19432 then 590 
 when 19430 then 591 
 when 161216 then 592 
 when 219694 then 593 
 when 122440 then 594 
 when 122446 then 595 
 when 262966 then 596 
 when 75281 then 597 
 when 271489 then 598 
 when 114030 then 599 
 when 214813 then 600 
 when 175851 then 601 
 when 201522 then 602 
 when 276723 then 603 
 when 61170 then 604 
 when 253390 then 605 
 when 78406 then 606 
 when 79229 then 607 
 when 115921 then 608 
 when 255294 then 609 
 when 280170 then 610 
 when 133695 then 611 
 when 135513 then 612 
 when 155228 then 613 
 when 168068 then 614 
 when 140147 then 615 
 when 252944 then 616 
 when 263637 then 617 
 when 291449 then 618 
 when 309659 then 619 
 when 189567 then 620 
 when 123105 then 621 
 when 220298 then 622 
 when 251881 then 623 
 when 277236 then 624 
 when 209505 then 625 
 when 247442 then 626 
 when 170725 then 627 
 when 170723 then 628 
 when 267480 then 629 
 when 122230 then 630 
 when 19434 then 631 
 when 28095 then 632 
 when 162546 then 633 
 when 151846 then 634 
 when 159470 then 635 
 when 193940 then 636 
 when 118076 then 637 
 when 173434 then 638 
 when 292810 then 639 
 when 250916 then 640 
 when 264483 then 641 
 when 277062 then 642 
 when 253388 then 643 
 when 124713 then 644 
 when 122441 then 645 
 when 118138 then 646 
 when 289944 then 647 
 when 86577 then 648 
 when 111012 then 649 
 when 193534 then 650 
 when 249007 then 651 
 when 247062 then 652 
 when 108230 then 653 
 when 261037 then 654 
 when 103823 then 655 
 when 163768 then 656 
 when 131401 then 657 
 when 264694 then 658 
 when 289710 then 659 
 when 217668 then 660 
 when 47987 then 661 
 when 289116 then 662 
 when 289117 then 663 
 when 122077 then 664 
 when 145522 then 665 
 when 179535 then 666 
 when 199041 then 667 
 when 205661 then 668 
 when 156653 then 669 
 when 175295 then 670 
 when 131325 then 671 
 when 246991 then 672 
 when 246816 then 673 
 when 249582 then 674 
 when 291450 then 675 
 when 291451 then 676 
 when 195482 then 677 
 when 198832 then 678 
 when 249265 then 679 
 when 44875 then 680 
 when 191643 then 681 
 when 263639 then 682 
 when 263638 then 683 
 when 270012 then 684 
 when 270013 then 685 
 when 206179 then 686 
 when 284310 then 687 
 when 168352 then 688 
 when 61173 then 689 
 when 61172 then 690 
 when 247587 then 691 
 when 179265 then 692 
 when 299130 then 693 
 when 207003 then 694 
 when 219665 then 695 
 when 253727 then 696 
 when 263031 then 697 
 when 85710 then 698 
 when 95332 then 699 
 when 132580 then 700 
 when 138447 then 701 
 when 47992 then 702 
 when 155229 then 703 
 when 105742 then 704 
 when 207438 then 705 
 when 280541 then 706 
 when 198825 then 707 
 when 251869 then 708 
 when 251868 then 709 
 when 251871 then 710 
 when 124209 then 711 
 when 253020 then 712 
 when 137726 then 713 
 when 266476 then 714 
 when 129325 then 715 
 when 275904 then 716 
 when 277025 then 717 
 when 155604 then 718 
 when 276685 then 719 
 when 149613 then 720 
 when 114111 then 721 
 when 116423 then 722 
 when 291448 then 723 
 when 246948 then 724 
 when 262967 then 725 
 when 153211 then 726 
 when 179485 then 727 
 when 206670 then 728 
 when 218505 then 729 
 when 250219 then 730 
 when 263033 then 731 
 when 263039 then 732 
 when 152842 then 733 
 when 181922 then 734 
 when 179686 then 735 
 when 284008 then 736 
 when 284009 then 737 
 when 298681 then 738 
 when 195966 then 739 
 when 154731 then 740 
 when 215040 then 741 
 when 112060 then 742 
 when 181821 then 743 
 when 207039 then 744 
 when 207108 then 745 
 when 209441 then 746 
 when 207041 then 747 
 when 87006 then 748 
 when 151222 then 749 
 when 53894 then 750 
 when 191648 then 751 
 when 263763 then 752 
 when 75116 then 753 
 when 144265 then 754 
 when 158620 then 755 
 when 162541 then 756 
 when 172160 then 757 
 when 285037 then 758 
 when 163770 then 759 
 when 191499 then 760 
 when 263367 then 761 
 when 289884 then 762 
 when 254568 then 763 
 when 213799 then 764 
 when 90010 then 765 
 when 144789 then 766 
 when 206418 then 767 
 when 256532 then 768 
 when 300524 then 769 
 when 201608 then 770 
 when 261791 then 771 
 when 121689 then 772 
 when 204074 then 773 
 when 168298 then 774 
 when 263634 then 775 
 when 266702 then 776 
 when 162554 then 777 
 when 284454 then 778 
 when 289723 then 779 
 when 289726 then 780 
 when 152048 then 781 
 when 263658 then 782 
 when 138449 then 783 
 when 191741 then 784 
 when 267071 then 785 
 when 201781 then 786 
 when 199867 then 787 
 when 112708 then 788 
 when 48119 then 789 
 when 181406 then 790 
 when 202781 then 791 
 when 209442 then 792 
 when 209327 then 793 
 when 256118 then 794 
 when 267466 then 795 
 when 262996 then 796 
 when 158345 then 797 
 when 133390 then 798 
 when 251263 then 799 
 when 270124 then 800 
 when 292078 then 801 
 when 296613 then 802 
 when 296460 then 803 
 when 162594 then 804 
 when 178948 then 805 
 when 191731 then 806 
 when 192567 then 807 
 when 286955 then 808 
 when 161105 then 809 
 when 139936 then 810 
 when 266489 then 811 
 when 191646 then 812 
 when 252855 then 813 
 when 211393 then 814 
 when 211394 then 815 
 when 113456 then 816 
 when 138436 then 817 
 when 250741 then 818 
 when 303796 then 819 
 when 277238 then 820 
 when 217917 then 821 
 when 255615 then 822 
 when 216782 then 823 
 when 264420 then 824 
 when 266490 then 825 
 when 264832 then 826 
 when 268760 then 827 
 when 271673 then 828 
 when 170661 then 829 
 when 122795 then 830 
 when 276849 then 831 
 when 275839 then 832 
 when 277982 then 833 
 when 122734 then 834 
 when 204184 then 835 
 when 246302 then 836 
 when 253438 then 837 
 when 262207 then 838 
 when 249902 then 839 
 when 277983 then 840 
 when 282773 then 841 
 when 260514 then 842 
 when 277240 then 843 
 when 285095 then 844 
 when 127000 then 845 
 when 209840 then 846 
 when 277980 then 847 
 when 149189 then 848 
 when 217242 then 849 
 when 263034 then 850 
 when 181367 then 851 
 when 214892 then 852 
 when 250703 then 853 
 when 122443 then 854 
 when 262975 then 855 
 when 297794 then 856 
 when 99676 then 857 
 when 132688 then 858 
 when 121353 then 859 
 when 263787 then 860 
 when 205360 then 861 
 when 152845 then 862 
 when 263043 then 863 
 when 209343 then 864 
 when 267303 then 865 
 when 267631 then 866 
 when 173303 then 867 
 when 217126 then 868 
 when 205235 then 869 
 when 302950 then 870 
 when 207337 then 871 
 when 251870 then 872 
 when 250485 then 873 
 when 218049 then 874 
 when 271312 then 875 
 when 250394 then 876 
 when 172633 then 877 
 when 250726 then 878 
 when 72688 then 879 
 when 220598 then 880 
 when 277984 then 881 
 when 189618 then 882 
 when 199621 then 883 
 when 277890 then 884 
 when 286960 then 885 
 when 135340 then 886 
 when 168404 then 887 
 when 138716 then 888 
 when 215820 then 889 
 when 117398 then 890 
 when 119049 then 891 
 when 113471 then 892 
 when 121668 then 893 
 when 253719 then 894 
 when 206978 then 895 
 when 251974 then 896 
 when 282168 then 897 
 when 248245 then 898 
 when 152909 then 899 
 when 216783 then 900 
 when 266491 then 901 
 when 291985 then 902 
 when 127512 then 903 
 when 279451 then 904 
 when 276185 then 905 
 when 160796 then 906 
 when 113452 then 907 
 when 249448 then 908 
 when 220704 then 909 
 when 277981 then 910 
 when 272201 then 911 
 when 101227 then 912 
 when 115898 then 913 
 when 206453 then 914 
 when 286764 then 915 
 when 168299 then 916 
 when 272181 then 917 
 when 300861 then 918 
 when 114863 then 919 
 when 283476 then 920 
 when 272159 then 921 
 when 250052 then 922 
 when 131470 then 923 
 when 131471 then 924 
 when 113455 then 925 
 when 117395 then 926 
 when 113475 then 927 
 when 257067 then 928 
 when 250484 then 929 
 when 170708 then 930 
 when 20086 then 931 
 when 292823 then 932 
 when 206480 then 933 
 when 113469 then 934 
 when 286763 then 935 
 when 137161 then 936 
 when 285354 then 937 
 when 294933 then 938 
 when 288124 then 939 
 when 300863 then 940 
 when 193594 then 941 
 when 217915 then 942 
 when 290872 then 943 
 when 290873 then 944 
 when 309737 then 945 
 when 124458 then 946 
 when 173304 then 947 
 when 153354 then 948 
 when 285134 then 949 
 when 276247 then 950 
 when 49865 then 951 
 when 227472 then 952 
 when 122447 then 953 
 when 138434 then 954 
 when 208034 then 955 
 when 253326 then 956 
 when 247547 then 957 
 when 277244 then 958 
 when 154970 then 959 
 when 149766 then 960 
 when 276193 then 961 
 when 283640 then 962 
 when 277246 then 963 
 when 288880 then 964 
 when 169708 then 965 
 when 169813 then 966 
 when 203000 then 967 
 when 276184 then 968 
 when 291447 then 969 
 when 181414 then 970 
 when 189123 then 971 
 when 276848 then 972 
 when 123816 then 973 
 when 270219 then 974 
 when 286762 then 975 
 when 305561 then 976 
 when 276232 then 977 
 when 206454 then 978 
 when 210651 then 979 
 when 280740 then 980 
 when 175574 then 981 
 when 276840 then 982 
 when 290002 then 983 
 when 166588 then 984 
 when 292650 then 985 
 when 115899 then 986 
 when 137157 then 987 
 when 252759 then 988 
 when 151279 then 989 
 when 49782 then 990 
 when 141233 then 991 
 when 266034 then 992 
 when 302968 then 993 
 when 126635 then 994 
 when 118049 then 995 
 when 300860 then 996 
 when 24704 then 997 
 when 191718 then 998 
 when 191716 then 999 
 when 217132 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (218218,250170,198931,291781,277576,205238,264644,263211,137602,291096,250171,158537,291094,132087,268755,284838,250397,289714,88551,155841,283475,262978,246408,157927,162555,244959,213381,123538,168522,156448,268663,277979,168070,217217,192568,284006,168069,193375,195483,267328,195484,219944,251969,266700,211037,155772,48126,214888,64020,202779,147585,202750,144448,199042,205240,175432,205255,111737,227133,189589,262986,87888,116293,120430,129534,141427,155227,157716,162540,251526,249134,268155,152857,267905,48158,112780,79479,189580,183755,197445,206669,291782,205256,249778,129502,129975,79095,120706,163767,163769,119381,214489,255466,227689,277783,287455,181371,215812,267141,278367,210647,200119,217129,210649,253368,257085,264484,300686,115813,268154,268093,246375,254350,189787,189701,277967,286716,303866,193230,204077,228095,277941,199113,200120,198835,217212,168073,246380,249691,256328,267380,246371,291472,193408,303799,144144,131507,130326,251088,251814,217128,214889,246384,246403,246407,246331,283415,211391,134115,152874,103495,131840,131500,188134,205239,250202,276194,233710,286721,165464,246817,113466,213506,291168,262977,192893,225885,219792,209942,246377,250504,255468,278779,283645,277968,291634,172159,218178,303798,298000,117397,110981,250200,267937,132164,162542,131581,289697,121691,286720,168071,303423,303745,138432,168604,201609,205173,202476,201657,220441,250201,260515,163766,214887,115469,189594,122445,152861,152900,309315,277784,162539,205375,149988,285334,162543,113489,74602,215964,122442,181405,263215,260512,280259,253555,277234,250203,269834,222100,280596,270054,301227,137158,113450,256329,267507,219943,148090,175956,217768,246409,289701,309302,198833,297699,207504,282862,77945,81891,168072,289695,117396,120769,138431,301548,260511,264776,250204,263864,71050,250221,125108,202782,262948,222482,222333,280956,290652,155884,218104,282983,287453,289699,298287,201710,215559,269029,247846,289734,207474,207505,296456,305631,296584,292817,277237,202783,289719,89606,129979,274250,276195,301378,305651,300611,308275,86578,247883,270053,298961,86480,118320,155226,285809,263257,257300,284839,218468,286717,227545,222485,217906,152363,252130,262449,297384,299070,149765,197396,175958,217905,262983,214517,202845,249450,251036,291635,218176,290651,280258,252127,301228,200118,285431,89610,289739,298697,279326,138438,262949,208907,213634,277235,137160,140013,89299,298217,298216,263038,297582,250614,214516,169811,139938,218175,283648,250205,277966,253981,198834,126337,210846,293051,150129,273503,175957,254415,262206,303690,262203,283650,280745,251882,121988,151347,271313,271041,120342,216276,247848,252883,188991,262981,285097,201674,196811,228147,228144,228141,287575,214891,179496,204062,204061,148567,246328,175326,159485,170821,144251,283392,205254,169809,138097,206469,148134,158312,201655,221021,247732,94966,228150,198548,114629,261465,169804,195453,225294,280000,114838,291085,298434,298481,196632,179487,260894,196812,206005,208933,193214,286276,286277,158311,301850,176040,205236,180058,196633,247451,216781,271308,170697,191500,280595,202860,201654,201652,210121,298167,196526,205813,246815,286285,148343,293544,280730,205433,285394,205251,138569,205241,141661,150211,284453,280160,193218,193224,195452,206018,285113,298165,193205,168301,225363,221036,155230,220874,206455,89297,282760,252554,199795,138437,249345,165466,252128,214890,206452,249449,303688,281165,222524,170687,193223,211975,208482,280967,301377,220209,255183,281486,213844,293056,293057,206466,205248,253257,138605,286482,215561,158686,170704,248653,288972,152843,225361,255173,155622,290906,277781,208481,201653,72816,137472,261510,293047,260776,261491,213380,216928,70304,280513,289737,211392,283643,304186,122444,283651,89614,227954,263829,134509,205253,70300,161825,191697,277919,217130,133210,186944,218177,222478,245230,285481,87024,132602,79756,252354,278695,283411,152877,113453,113449,124715,170682,170724,211036,195486,173900,218179,202846,216504,288973,150574,123424,217903,121056,261953,301158,286887,247847,277239,271311,125460,249453,176419,79755,47985,285139,19432,19430,161216,219694,122440,122446,262966,75281,271489,114030,214813,175851,201522,276723,61170,253390,78406,79229,115921,255294,280170,133695,135513,155228,168068,140147,252944,263637,291449,309659,189567,123105,220298,251881,277236,209505,247442,170725,170723,267480,122230,19434,28095,162546,151846,159470,193940,118076,173434,292810,250916,264483,277062,253388,124713,122441,118138,289944,86577,111012,193534,249007,247062,108230,261037,103823,163768,131401,264694,289710,217668,47987,289116,289117,122077,145522,179535,199041,205661,156653,175295,131325,246991,246816,249582,291450,291451,195482,198832,249265,44875,191643,263639,263638,270012,270013,206179,284310,168352,61173,61172,247587,179265,299130,207003,219665,253727,263031,85710,95332,132580,138447,47992,155229,105742,207438,280541,198825,251869,251868,251871,124209,253020,137726,266476,129325,275904,277025,155604,276685,149613,114111,116423,291448,246948,262967,153211,179485,206670,218505,250219,263033,263039,152842,181922,179686,284008,284009,298681,195966,154731,215040,112060,181821,207039,207108,209441,207041,87006,151222,53894,191648,263763,75116,144265,158620,162541,172160,285037,163770,191499,263367,289884,254568,213799,90010,144789,206418,256532,300524,201608,261791,121689,204074,168298,263634,266702,162554,284454,289723,289726,152048,263658,138449,191741,267071,201781,199867,112708,48119,181406,202781,209442,209327,256118,267466,262996,158345,133390,251263,270124,292078,296613,296460,162594,178948,191731,192567,286955,161105,139936,266489,191646,252855,211393,211394,113456,138436,250741,303796,277238,217917,255615,216782,264420,266490,264832,268760,271673,170661,122795,276849,275839,277982,122734,204184,246302,253438,262207,249902,277983,282773,260514,277240,285095,127000,209840,277980,149189,217242,263034,181367,214892,250703,122443,262975,297794,99676,132688,121353,263787,205360,152845,263043,209343,267303,267631,173303,217126,205235,302950,207337,251870,250485,218049,271312,250394,172633,250726,72688,220598,277984,189618,199621,277890,286960,135340,168404,138716,215820,117398,119049,113471,121668,253719,206978,251974,282168,248245,152909,216783,266491,291985,127512,279451,276185,160796,113452,249448,220704,277981,272201,101227,115898,206453,286764,168299,272181,300861,114863,283476,272159,250052,131470,131471,113455,117395,113475,257067,250484,170708,20086,292823,206480,113469,286763,137161,285354,294933,288124,300863,193594,217915,290872,290873,309737,124458,173304,153354,285134,276247,49865,227472,122447,138434,208034,253326,247547,277244,154970,149766,276193,283640,277246,288880,169708,169813,203000,276184,291447,181414,189123,276848,123816,270219,286762,305561,276232,206454,210651,280740,175574,276840,290002,166588,292650,115899,137157,252759,151279,49782,141233,266034,302968,126635,118049,300860,24704,191718,191716,217132)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'ammo'
 
  and ltrim(rtrim(lower(a.brand))) = 'winchester ammo'
 
	and a.of3='9 MM'
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =72688 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=72688 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 72688 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 72688 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:38' and
end_date >= 'May 20, 2024 14:36:38'
and store_id=10 and style_id=72688

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 72688 
and (a.start_date<= 'May 20, 2024 14:36:38' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:38'
order by a.promo_id desc

Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='9mm Luger' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=72688  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=72688
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =215040 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=215040 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 215040 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 215040 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='9mm Luger' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=215040  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=215040
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =267071 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=267071 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 267071 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 267071 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='9mm Luger' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=267071  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=267071
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =286955 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=286955 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 286955 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 286955 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='9mm Luger' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=286955  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=286955
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =161105 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=161105 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 161105 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 161105 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='9mm Luger' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=161105  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=161105
												and status='A' 
												and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\websites\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\websites\images\
logdir=E:\websites\logs\
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\websites\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-5054; CFGLOBALS=urltoken%3DCFID%23%3D5054%26CFTOKEN%23%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A38%27%7D%23hitcount%3D69%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A02%27%7D%23cftoken%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23cfid%3D5054%23; LAST_NAME=; FIRST_NAME=; PRD_U=307380%2C3273; CUSTOMER_ID=; USERNAME=; EMAIL=; PASSWORD=; CT_U=91
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/SIG%20Sauer%20P210%20Standard%209mm%20Luger%20Semi%20Auto%20Pistol%20/dept/ammo/brand/winchester%20ammo/of3/9%20mm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/SIG Sauer P210 Standard 9mm Luger Semi Auto Pistol /dept/ammo/brand/winchester ammo/of3/9 mm
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
hitcount=69
lastvisit={ts '2024-05-20 14:36:38'}
timecreated={ts '2024-05-20 14:36:02'}
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

Cookie Variables:
CFGLOBALS=urltoken=CFID#=5054&CFTOKEN#=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#lastvisit={ts '2024-05-20 14:36:38'}#hitcount=69#timecreated={ts '2024-05-20 14:36:02'}#cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#cfid=5054#
CFID=5054
CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
CT_U=91
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=307380,3273
USERNAME=

Form Fields:
KWORD=SIG Sauer P210 Standard 9mm Luger Semi Auto Pistol 
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
cs=/category.cfm/sportsman/belt-holsters/brand/galco-international/make/walther/model/p95
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_5054_ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
strarray=Array (0)
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

URL Parameters:
CLEARANCE=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=winchester ammo
dept=ammo
kword=SIG Sauer P210 Standard 9mm Luger Semi Auto Pistol 
of3=9 mm